{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["June 15 Calculator"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"June 15 Calculator","index":0,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,33,7,33],[6,34,7,34],[0,0,0,32]]}
["June 15 Calculator"]
[null,"q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15a","q15b","q16","q17","q18","q19","q20","q21","q22","q23","q24","q25","q26a","q26b","q26c","q27","q28a","q28b",null,"q28"]
[null,"Probability","Trial and Improvement","Using a Calculator","Enlargements","Using a Calculator","Best Buys","Expanding and Factorising","Ratio","Frequency Polygons","Loci and Construction","Area and Circumference of Circles","Averages and Range","Bearings","Averages from Frequency Tables","Fractional & Negative Indices","Standard Form","Compound Measures","Y=MX+ C Harder","Box plots","Trigonometry","Proof","Similar Shapes","Reverse %","Sine, Cosine Rules & Area of Triangles","Upper and Lower Bounds","Solving Quadratics Using the Formula","Histograms","Histograms","Histograms","Vectors","Area and Circumference of Circles","Solving Simultaneous Equations Graphically","Sine, Cosine Rules & Area of Triangles","Histograms","Proving Congruency"]
["Max Mark",5,4,3,2,5,4,4,3,4,3,4,3,2,4,1,2,4,3,3,4,3,2,3,3,4,3,2,2,2,4,2,3]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.6},0.4375,0.47619047619047622,0.5357142857142857,0.6,0.44642857142857145,0.4107142857142857,0.5357142857142857,0.48214285714285715,0.59523809523809523,0.5446428571428571,0.40476190476190471,0.48214285714285715,0.44642857142857145,0.35714285714285715,0.4107142857142857,0.5,0.47619047619047622,0.52380952380952384,0.41964285714285715,0.41666666666666669,0.5357142857142857,0.5357142857142857,0.5,0.5178571428571429,0.54761904761904756,{"$f":"AVERAGE(AB9:AB40)/AB4","v":0.44642857142857145},0.4642857142857143,0.48214285714285715,{"$f":"AVERAGE(AE9:AE40)/AE4","v":0.45535714285714285},0.5535714285714286,0.5714285714285714]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.33554819712314443},0.344433243545479,0.30669580415215741,0.38317802236740667,0.30307070437746347,0.33580433330222265,0.29825329244624688,0.24577559630479404,0.32580790912866692,0.26226526415648099,0.30469756885411553,0.35552248523454688,0.41904085492376292,0.33580433330222265,0.4879500364742666,0.33481812167679126,0.3042903097250923,0.31983240761285531,0.35634832254989918,0.27262078047553523,0.29571702634576508,0.40662503039522213,0.31868151360482566,0.27962349760262034,0.31862385978009244,0.3653093363557644,{"$f":"IF(COUNT(AB9:AB36)<2,\"\",STDEV(AB9:AB40)/AB4)","v":0.39297737457927134},0.38317802236740672,0.31862385978009244,{"$f":"IF(COUNT(AE9:AE36)<2,\"\",STDEV(AE9:AE40)/AE4)","v":0.30469756885411553},0.31444500532789738,0.31239342685979915]
[null,"q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15a","q15b","q16","q17","q18","q19","q20","q21","q22","q23","q24","q25","q26a","q26b","q26c","q27","q28a","q28b","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*B$4,0)","v":4},{"$f":"ROUND(RAND()*C$4,0)","v":1},1,1,3,1,3,2,2,3,0,2,0,4,0,0,4,1,1,3,0,1,2,1,0,3,0,0,1,3,1,3,{"$f":"IF(AG9=\"\",\"\",SUM(B9:AG9))","v":51},{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,$AK$13:$AL$34,2))","v":"B2"}]
["Sample student 2",{"$f":"ROUND(RAND()*B$4,0)","v":5},4,1,2,1,0,3,1,3,1,3,1,1,3,1,1,0,1,0,0,1,0,2,0,2,3,2,0,0,1,1,3,{"$f":"IF(AG10=\"\",\"\",SUM(B10:AG10))","v":47},{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,$AK$13:$AL$34,2))","v":"B3"},null,"Grade Boundaries"]
["Sample student 3",4,4,1,2,4,4,1,1,3,1,2,2,2,2,0,1,2,1,2,0,2,0,3,2,3,2,1,0,1,3,2,2,60,"B1"]
["Sample student 4",4,2,2,1,5,1,1,1,2,2,2,1,1,1,0,1,2,1,3,2,1,0,0,1,4,1,0,1,1,2,1,2,49,"B3",null,"Mark","Grade"]
["Sample student 5",4,2,1,2,1,4,3,1,1,2,3,1,2,1,0,1,1,1,3,1,1,1,0,2,4,2,1,2,2,2,1,3,56,"B1",null,0,"F3"]
["Sample student 6",3,1,2,0,5,2,2,3,0,2,4,2,2,2,0,2,3,0,3,2,1,0,1,3,3,3,1,1,1,2,0,1,57,"B1",null,{"$f":"AK13+(AK16-AK13)/3","v":3.3333333333333335},"F2"]
["Sample student 7",1,1,2,0,4,2,2,2,3,3,4,1,1,0,0,0,4,3,2,0,1,1,2,2,3,3,0,2,1,1,1,2,54,"B2",null,{"$f":"AK13+2*(AK16-AK13)/3","v":6.666666666666667},"F1"]
["Sample student 8",2,1,1,0,3,3,3,1,2,3,3,0,2,2,0,0,3,1,3,1,2,2,1,2,0,2,0,0,1,0,1,2,47,"B3",null,10,"E3"]
["Sample student 9",2,3,2,1,2,0,4,1,{"$f":"ROUND(RAND()*J$4,0)","v":0},1,2,1,1,3,0,1,3,2,3,3,1,2,1,1,{"$f":"ROUND(RAND()*Z$4,0)","v":1},0,0,1,0,1,2,3,48,"B3",null,{"$f":"AK16+(AK19-AK16)/3","v":12.666666666666666},"E2"]
["Sample student 10",3,4,0,1,5,2,1,1,2,1,1,2,2,2,1,0,0,2,1,2,1,2,1,1,0,3,1,0,1,3,1,1,48,"B3",null,{"$f":"AK16+2*(AK19-AK16)/3","v":15.333333333333332},"E1"]
["Sample student 11",0,1,0,1,5,2,2,1,3,1,2,3,1,1,1,1,2,1,2,3,2,2,3,3,3,3,1,1,1,2,0,0,54,"B2",null,18,"D3"]
["Sample student 12",4,1,1,2,4,1,2,3,3,2,2,3,2,1,1,0,1,2,3,1,0,2,2,2,2,2,0,1,0,1,1,1,53,"B2",null,{"$f":"AK19+(AK22-AK19)/3","v":22.666666666666668},"D2"]
["Sample student 13",5,1,3,0,3,0,0,2,0,3,1,0,0,3,1,1,1,3,0,3,1,1,1,1,2,1,0,2,1,0,2,1,43,"C1",null,{"$f":"AK19+2*(AK22-AK19)/3","v":27.333333333333336},"D1"]
["Sample student 14",1,1,0,2,3,1,1,2,1,1,2,0,0,0,1,1,1,0,1,2,1,1,1,1,2,3,2,2,1,2,2,1,40,"C2",null,32,"C3"]
["Sample student 15",0,0,2,0,3,0,1,2,1,1,0,3,2,4,1,1,2,2,0,4,1,0,2,2,2,2,2,1,1,3,2,3,50,"B3",null,{"$f":"AK22+(AK25-AK22)/3","v":36.666666666666664},"C2"]
["Sample student 16",3,0,1,1,4,0,3,2,4,1,3,3,1,0,0,0,1,2,1,2,1,0,1,1,3,0,2,0,2,1,1,1,45,"C1",null,{"$f":"AK22+2*(AK25-AK22)/3","v":41.333333333333336},"C1"]
["Sample student 17",3,4,1,2,1,2,0,3,3,2,3,2,0,3,1,0,1,3,1,1,3,2,1,1,3,2,1,1,0,2,1,3,56,"B1",null,46,"B3"]
["Sample student 18",0,3,2,1,2,4,0,2,0,1,0,0,1,2,0,1,2,1,3,3,3,1,1,1,4,1,1,2,2,1,1,1,47,"B3",null,{"$f":"AK25+(AK28-AK25)/3","v":51},"B2"]
["Sample student 19",5,4,2,1,2,4,1,0,1,3,4,0,2,0,0,1,0,3,0,1,0,0,2,3,2,1,2,1,0,4,1,2,52,"B2",null,{"$f":"AK25+2*(AK28-AK25)/3","v":56},"B1"]
["Sample student 20",2,0,1,0,3,1,3,1,3,2,1,1,0,4,1,1,3,1,2,2,0,2,3,1,3,2,1,0,1,1,2,0,48,"B3",null,61,"A3"]
["Sample student 21",4,3,2,2,5,1,2,2,3,2,2,2,2,1,0,2,1,1,1,2,1,1,3,3,1,0,0,1,1,2,0,1,54,"B2",null,{"$f":"AK28+(AK31-AK28)/3","v":66},"A2"]
["Sample student 22",4,1,3,2,1,2,1,1,1,1,1,0,1,0,0,1,3,1,1,2,0,2,3,0,1,0,2,1,1,1,0,2,40,"C2",null,{"$f":"AK28+2*(AK31-AK28)/3","v":71},"A1"]
["Sample student 23",5,1,1,1,2,1,2,1,4,2,1,0,0,3,0,0,4,1,2,1,2,2,0,2,4,2,1,2,2,4,1,2,56,"B1",null,76," A*3"]
["Sample student 24",5,1,3,0,5,2,0,2,1,3,4,0,1,1,0,1,2,2,2,1,1,1,1,1,1,1,0,2,1,4,2,1,52,"B2",null,{"$f":"AK31+(AK34-AK31)/3","v":84},"A*2"]
["Sample student 25",3,0,3,1,1,2,0,{"$f":"ROUND(RAND()*I$4,0)","v":2},0,1,3,1,0,1,1,2,2,0,0,0,2,1,3,1,2,0,1,0,2,2,1,1,39,"C2",null,{"$f":"AK31+2*(AK34-AK31)/3","v":92},"A*1"]
["Sample student 26",{"$f":"ROUND(RAND()*B$4,0)","v":0},1,0,2,4,1,3,1,4,2,3,1,0,3,0,1,2,0,1,1,2,0,1,1,1,0,2,0,0,0,1,3,41,"C2",null,100,"A*1"]
["Sample student 27",4,1,1,1,3,3,0,2,2,2,3,0,0,3,0,0,4,1,1,3,3,1,2,2,2,2,0,1,1,3,1,1,53,"B2"]
["Sample student 28",4,3,1,1,0,4,2,2,2,1,2,2,0,0,0,2,2,3,2,1,1,2,2,1,0,2,1,1,1,0,1,2,48,"B3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]